select 
to_Days(date_added) as aday,
round(date_added/1000000)  as SalesDate,  
sum(value) as SalesValue

from 
<@PREFIX>order,
<@PREFIX>order_total 

where 
<@PREFIX>order.order_id = <@PREFIX>order_total.order_id and 
order_total.code ="ot_total" and 
date_added <= %s and 
date_added >= %s

group by 
to_Days(date_added)

order by 
date_added desc